package net.kesumu.yushabu.storage;

import android.provider.BaseColumns;

public class YushabuSessionContract {

    public YushabuSessionContract() {
    }

    public static final String TEXT_TYPE = " TEXT";
    public static final String COMMA_SEP = ",";
    public static final String SQL_CREATE_ENTRY_YUSHABUSESSION =
        "CREATE TABLE " + YushabuSessionEntry.TABLE_NAME + " (" +
        YushabuSessionEntry._ID + " INTEGER PRIMARY KEY," +
        YushabuSessionEntry.COLUMN_NAME_SESSIONID + TEXT_TYPE + COMMA_SEP +
        YushabuSessionEntry.COLUMN_NAME_TYPE + TEXT_TYPE + COMMA_SEP +
        YushabuSessionEntry.COLUMN_NAME_CREATEDTIME + TEXT_TYPE + COMMA_SEP +
        YushabuSessionEntry.COLUMN_NAME_NAME + TEXT_TYPE + COMMA_SEP + 
        YushabuSessionEntry.COLUMN_NAME_FRIENDID + TEXT_TYPE + COMMA_SEP + 
        YushabuSessionEntry.COLUMN_NAME_FRIENDNAME + TEXT_TYPE + 
        " )";

    public static final String SQL_DELETE_ENTRY_YUSHABUSESSION =
        "DROP TABLE IF EXISTS " + YushabuSessionEntry.TABLE_NAME;

    public static abstract class YushabuSessionEntry implements BaseColumns {
        public static final String TABLE_NAME = "yushabusession";
        public static final String COLUMN_NAME_SESSIONID = "sessionId";
        public static final String COLUMN_NAME_TYPE = "type";
        public static final String COLUMN_NAME_CREATEDTIME = "createdTime";
        public static final String COLUMN_NAME_NAME = "name";
        public static final String COLUMN_NAME_FRIENDID = "friendId";
        public static final String COLUMN_NAME_FRIENDNAME = "friendName";
    }
}
